Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
RecipeID (PK) | A system assigned unique identifier for the recipe | ID_RCPE | Identity | integer | |
ItemID (FK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | PreparedItem(AS_ITM_PPR) |
RecipeVariationOf (FK) | A system assigned unique identifier for the recipe which this recipe is a variation of | CD_VRT | Identity | integer | Recipe(ST_RCP) |
LastChangeDate | The date the recipe was last changed. | DC_CHN_LS | DateCalendar | date | |
CreateDate | The date the recipe was created | DC_CRT | DateCalendar | date | |
StatusCode | The status of the recipe, possible values include Active, Inactive, Testing | SC_RCPE | Code2 | char(2) | |
Description | A short narrative description describing the recipe. When the recipe is a variant of another recipe, the description includes a description of the variation. | DE_RCPE | DescriptionNarrative | varchar(4000) | |